-
Re: Forms Security Setting
If the link is shared, then anyone can input into their answers into the form? Yes. But to truly "lock down" the page, you will need to create new groups for the sub-site; remove the top-le…1 · -
Re: Can a barcode scanner be used in conjunction with Smartsheet Asset Management
@Qtnguyen We use barcodes regularly in our collection of sheets. Think of a barcode scanner as an input device much like your keyboard. However, instead of individual keystrokes, the scanner scans, p…1 · -
Re: Blank do not Concatenate
Column 1 - Column 2 - Column 4 - Column 5 In that case JOIN(COLLECT()) will not work, because COLLECT() requires a range. If you have something in Column 3, JOIN(COLLECT()) will include that value. D…1 · -
Re: Previous, Current, and Next Weeks with New Year
Another approach is to use NETDAYS() to find the number of days between the two dates, and then divide it by 7. Taking the integer, INT(), will return the number of weeks. The expression is: INT(NETD…1 · -
Re: Date & Timestamp a specific cell change
@MBMaddox Hi, here is another approach. Let's say that your sheet is called My Sheet. Ensure that this sheet has the system column "Modified Date". In this sheet: 1) Create a Text/Number co…3 ·